--TRG_AUR_B_IU_DAT
--TRG_AUR_B_I_PK
--
CREATE OR REPLACE TRIGGER TRG_AUR_B_I_PK
BEFORE INSERT
ON AUTROOT
FOR EACH ROW
BEGIN
  SELECT AUTROOT_AUR_ID_SEQ.NEXTVAL
  INTO :NEW.AUR_ID
  FROM DUAL;
END;
/



CREATE OR REPLACE TRIGGER TRG_AUR_B_IU_DAT
BEFORE INSERT OR UPDATE
ON AUTROOT
FOR EACH ROW
BEGIN
   IF INSERTING THEN
      :NEW.AUR_CREATINGDATE := SYSDATE;
      :NEW.AUR_MODIFYINGDATE := SYSDATE;
   END IF;

   IF UPDATING THEN
      :NEW.AUR_MODIFYINGDATE := SYSDATE;
   END IF;
END;
-- ************* END AUTROOT ***********
/




